<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

class THisdataSoilcondth extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('t_hisdata_SoilCondTH', function (Blueprint $table) {
             $table->engine = 'MyISAM';
             $table->charset = 'utf8';
             $table->collation = 'utf8_general_ci';
            // CONTENT
            $table->bigIncrements('hd_index')->nullable(false)->comment('');
			$table->datetime('rd_updatetime')->nullable(false)->comment('');
			$table->datetime('hd_datetime')->nullable(false)->comment('');
			$table->unsignedBigInteger('pdi_index')->nullable(false)->default(0)->comment('');
			$table->float('hd_Soiltemp1', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp2', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp3', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp4', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp5', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp6', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp7', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp8', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp9', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soiltemp10', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi1', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi2', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi3', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi4', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi5', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi6', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi7', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi8', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi9', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_Soilhumi10', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond1', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond2', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond3', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond4', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond5', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond6', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond7', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond8', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond9', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilCond10', 9, 2)->nullable()->default(0)->comment('');
			$table->float('hd_SoilTH_num', 9, 2)->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp1hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp2hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp3hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp4hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp5hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp6hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp7hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp8hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp9hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp10hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp1lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp2lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp3lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp4lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp5lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp6lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp7lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp8lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp9lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soiltemp10lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi1hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi2hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi3hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi4hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi5hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi6hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi7hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi8hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi9hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi10hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi1lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi2lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi3lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi4lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi5lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi6lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi7lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi8lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi9lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_Soilhumi10lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond1hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond2hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond3hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond4hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond5hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond6hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond7hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond8hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond9hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond10hwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond1lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond2lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond3lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond4lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond5lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond6lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond7lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond8lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond9lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_SoilCond10lwarn')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi1consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi2consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi3consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi4consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi5consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi6consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi7consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi8consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi9consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_envihumi10consta')->nullable()->default(0)->comment('');
			$table->boolean('hd_NetCom')->nullable()->default(0)->comment('');
			$table->unique('hd_index', 'hd_index');
			
        });

        
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('t_hisdata_SoilCondTH');
    }
}
